{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["HOME","INGREDIENTS","PRICING REPORT","INGREDIENT REPORT","ADD RECIPE","TEMPLATE","R-CAKE","R-SANDWICH","R-DRINKS","R-Cat 4","R-Cat 5"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"HOME","index":0,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,10]]}
[]
[null,"RECIPE COSTING TOOL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-06-24"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L4>L5,\"X\",\"\")","v":"X"}]

{"sheet":"INGREDIENTS","index":1,"n_rows":415,"n_cols":7,"rows_kept":415,"cut":false,"hidden":false,"merged":[]}
[null,"Ingredients","Size","Total Cost","Total Qty","Unit","Cost Per Each/Gm or Ml"]
[null,"UNSALTED BUTTER","Grams",25.6,1500,"Grams",{"$f":"IFERROR(D2/E2,0)","v":1.7066666666666667E-2}]
[null,"CASTER SUGAR","Grams",31.9,15000,"Grams",2.1266666666666665E-3]
[null,"DARK CHOC","Grams",74,2500,"Grams",2.9600000000000001E-2]
[null,"EGG","Grams",70,9000,"Grams",7.7777777777777776E-3]
[null,"STRONG FLOUR","Grams",25.85,12500,"Grams",2.068E-3]
[null,"COCOA POWDER","Grams",8.25,500,"Grams",1.6500000000000001E-2]
[null,"BAKING POWDER ","Grams",4.12,500,"Grams",8.2400000000000008E-3]
[null,"SALT","Grams",16.5,10000,"Grams",1.65E-3]
[null,"VANILLA","Grams",33,600,"Grams",5.5E-2]
[null,"GROUND COFFEE","Grams",32,1000,"Grams",3.2000000000000001E-2]
[null,"MUSTARD","Grams",20,2200,"Grams",9.0909090909090905E-3]
[null,"VEG OIL","Ml",67.5,20000,"Ml",3.375E-3]
[null,"SR FLOUR","Grams",16.77,12500,"Grams",1.3415999999999999E-3]
[null,"BROWN SUGAR","Grams",5.05,1000,"Grams",5.0499999999999998E-3]
[null,"BANANA","Grams",26,10000,"Grams",2.5999999999999999E-3]
[null,"00 FLOUR","Grams",22.75,12500,"Grams",1.82E-3]
[null,"EVOO","Grams",256.25,20000,"Grams",1.2812499999999999E-2]
[null,"YEAST","Grams",10,1000,"Grams",0.01]
[null,"FIOR DI LATTE","Grams",15.9,1000,"Grams",1.5900000000000001E-2]
[null,"GRANA PADANO","Grams",26.5,1000,"Grams",2.6499999999999999E-2]
[null,"PEELED TOMATOES","Grams",12.5,2500,"Grams",5.0000000000000001E-3]
[null,"BASIL","Grams",3.95,100,"Grams",3.95E-2]
[null,"VANILLA GELATO","Grams",40.75,5000,"Grams",8.1499999999999993E-3]
[null,"ICING SUGAR","Grams",6.5,1000,"Grams",6.4999999999999997E-3]
[null,"HOISIN SAUCE","Grams",42,11335,"Grams",3.7053374503749448E-3]
[null,"CHOC BROWNIE","Grams",106.94,8030,"Grams",1.3317559153175592E-2]
[null,"BREAD","Each",5,15,"No",0.33333333333333331]
[null,"LETUCE","Grams",5,1000,"Grams",5.0000000000000001E-3]
[null,"MEAT","Grams",7,1000,"Grams",{"$f":"IFERROR(D30/E30,0)","v":7.0000000000000001E-3}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"IFERROR(D65/E65,0)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"IFERROR(D129/E129,0)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"IFERROR(D193/E193,0)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"IFERROR(D257/E257,0)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"IFERROR(D321/E321,0)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"IFERROR(D385/E385,0)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]

{"sheet":"PRICING REPORT","index":2,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"RECIPE COSTING REPORT"]
[]
[]
[null,"SL NO","CAKE",null,null,"COST","UNIT"]
[null,1,"BROWNIE",null,null,1.06,"1 No"]
[null,2,"Butter Cake",null,null,2.85,"1 No"]
[null,3,"VANILA CAKE",null,null,4.28,"1 No"]
[]
[]
[null,"SL NO","SANDWICH",null,null,"COST","UNIT"]
[null,1,"Veg Sandwich",null,null,2.6,"1 No"]
[]
[]
[null,"SL NO","DRINKS",null,null,"COST","UNIT"]
[null,1,"BROWNIE SHAKE",null,null,4.25,"1 No"]
[]
[]
[null,"SL NO","Cat 4",null,null,"COST","UNIT"]
[]
[]
[null,"SL NO","Cat 5",null,null,"COST","UNIT"]

{"sheet":"INGREDIENT REPORT","index":3,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
["H","INGREDIENT REPORT",null,null,null,null,null,null,null,null,null,null,null,null,"00 FLOUR",7500,"Grams"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BAKING POWDER ",200,"Grams"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BAKING POWDER ",150,"Grams"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COCOA POWDER",3000,"Grams"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VEG OIL",40000,"Ml"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UNSALTED BUTTER",200,"Grams"]
["H","SL NO","RECIPE","QTY","Unit Size",null,null,"Recipe Sheet","Row No",null,null,null,null,null,"ICING SUGAR",1000,"Grams"]
[null,1,"BROWNIE",20,"10/No",null,null,"R-CAKE",{"$f":"IFERROR(MATCH(\"U-\" &C9,INDIRECT(\"'\" & H9 &\"'!B:B\"),FALSE),\"\")","v":6},null,null,null,null,null,"ICING SUGAR",3000,"Grams"]
[null,2,"Butter Cake",30,"1/No",null,null,"R-CAKE",{"$f":"IFERROR(MATCH(\"U-\" &C10,INDIRECT(\"'\" & H10 &\"'!B:B\"),FALSE),\"\")","v":22},null,null,null,null,null,"UNSALTED BUTTER",3000,"Grams"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VANILLA GELATO",2000,"Grams"]
[]
["H","SL NO","INDREDIENT","QTY","UNIT"]
[null,1,"00 FLOUR",7500,"Grams"]
[null,2,"BAKING POWDER ",350,"Grams"]
[null,3,"COCOA POWDER",3000,"Grams"]
[null,4,"VEG OIL",40000,"Ml"]
[null,5,"UNSALTED BUTTER",200,"Grams"]
[null,6,"ICING SUGAR",4000,"Grams"]
[null,7,"UNSALTED BUTTER",3000,"Grams"]
[null,8,"VANILLA GELATO",2000,"Grams"]

{"sheet":"ADD RECIPE","index":4,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"RECIPE NAME:","Recipe Name Here"]
[null,{"$f":"\"U-\" & D2","v":"U-Recipe Name Here"},"UNIT SIZE: ",1,"No"]
[null,null,"FINISHED QUANTITY: ",1,"No"]
[null,{"$f":"\"P-\" &D2","v":"P-Recipe Name Here"},"UNIT PRICE Rs:",{"$f":"IFERROR(ROUND(H24/D4*D3,2),0)","v":0},{"$f":"\"/\" & D3 & \" \" & E3","v":"/1 No"}]
[null,null,"PREPARATION","INGREDIENTS","RECIPE QUANTITY","RECIPE QTY UNIT","COSTING UNIT PRICE","RECIPE QTY COST"]
[null,"I",null,"Select Ingredient",0,null,null,{"$f":"IFERROR(PRODUCT(G7,E7),0)","v":0}]
[null,"I",null,"Select Ingredient",0,null,null,{"$f":"IFERROR(PRODUCT(G8,E8),0)","v":0}]
[null,"I",null,"Select Ingredient",0,null,null,0]
[null,"I",null,"Select Ingredient",0,null,null,0]
[null,"I",null,"Select Ingredient",0,null,null,0]
[null,"I",null,"Select Ingredient",0,null,null,0]
[null,"I",null,"Select Ingredient",0,null,null,0]
[null,"I",null,"Select Ingredient",0,null,null,0]
[null,"I",null,"Select Ingredient",0,null,null,0]
[null,"I",null,"Select Ingredient",0,null,null,0]
[null,"I",null,"Select Ingredient",0,null,null,{"$f":"IFERROR(PRODUCT(G17,E17),0)","v":0}]
[null,"I",null,"Select Ingredient",0,null,null,0]
[null,"I",null,"Select Ingredient",0,null,null,0]
[null,"I",null,"Select Ingredient",0,null,null,0]
[null,"I",null,"Select Ingredient",0,null,null,{"$f":"IFERROR(PRODUCT(G21,E21),0)","v":0}]
[null,"I"]
[]
[null,null,null,"TOTAL COST",null,null,null,{"$f":"SUM(H7:H23)","v":0}]

{"sheet":"TEMPLATE","index":5,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[[1,2,1,7]]}
[]
[null,null,"RECIPES"]

{"sheet":"R-CAKE","index":6,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,2,1,7]]}
[]
[null,null,"RECIPES"]
[]
[]
[null,null,"RECIPE NAME:","BROWNIE"]
[null,{"$f":"\"U-\" & D5","v":"U-BROWNIE"},"UNIT SIZE: ",1,"No"]
[null,null,"FINISHED QUANTITY: ",10,"No"]
[null,{"$f":"\"P-\" &D5","v":"P-BROWNIE"},"UNIT PRICE Rs:",{"$f":"IFERROR(ROUND(H18/D7*D6,2),0)","v":1.06},{"$f":"\"/\" & D6 & \" \" & E6","v":"/1 No"}]
[null,null,"PREPARATION","INGREDIENTS","RECIPE QUANTITY","RECIPE QTY UNIT","COSTING UNIT PRICE","RECIPE QTY COST"]
[null,"I",null,"BAKING POWDER ",10,{"$f":"IFERROR(VLOOKUP(D10,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D10,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":8.2400000000000008E-3},{"$f":"IFERROR(PRODUCT(G10,E10),0)","v":8.2400000000000001E-2}]
[null,"I",null,"COCOA POWDER",150,{"$f":"IFERROR(VLOOKUP(D11,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D11,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":1.6500000000000001E-2},2.4750000000000001]
[null,"I",null,"VANILLA GELATO",100,{"$f":"IFERROR(VLOOKUP(D12,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D12,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":8.1499999999999993E-3},0.81499999999999995]
[null,"I",null,"ICING SUGAR",50,{"$f":"IFERROR(VLOOKUP(D13,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D13,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":6.4999999999999997E-3},0.32500000000000001]
[null,"I",null,"VEG OIL",2000,{"$f":"IFERROR(VLOOKUP(D14,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Ml"},{"$f":"IFERROR(VLOOKUP(D14,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":3.375E-3},6.75]
[null,"I",null,"UNSALTED BUTTER",10,{"$f":"IFERROR(VLOOKUP(D15,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D15,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":1.7066666666666667E-2},0.17066666666666669]
[null,"I"]
[]
[null,null,null,"TOTAL COST",null,null,null,{"$f":"SUM(H10:H17)","v":10.618066666666667}]
[]
[]
[null,null,"RECIPE NAME:","Butter Cake"]
[null,{"$f":"\"U-\" & D21","v":"U-Butter Cake"},"UNIT SIZE: ",1,"No"]
[null,null,"FINISHED QUANTITY: ",1,"No"]
[null,{"$f":"\"P-\" &D21","v":"P-Butter Cake"},"UNIT PRICE Rs:",{"$f":"IFERROR(ROUND(H32/D23*D22,2),0)","v":2.85},{"$f":"\"/\" & D22 & \" \" & E22","v":"/1 No"}]
[null,null,"PREPARATION","INGREDIENTS","RECIPE QUANTITY","RECIPE QTY UNIT","COSTING UNIT PRICE","RECIPE QTY COST"]
[null,"I",null,"00 FLOUR",250,{"$f":"IFERROR(VLOOKUP(D26,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D26,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":1.82E-3},{"$f":"IFERROR(PRODUCT(G26,E26),0)","v":0.45500000000000002}]
[null,"I",null,"BAKING POWDER ",5,{"$f":"IFERROR(VLOOKUP(D27,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D27,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":8.2400000000000008E-3},{"$f":"IFERROR(PRODUCT(G27,E27),0)","v":4.1200000000000001E-2}]
[null,"I",null,"ICING SUGAR",100,{"$f":"IFERROR(VLOOKUP(D28,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D28,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":6.4999999999999997E-3},{"$f":"IFERROR(PRODUCT(G28,E28),0)","v":0.65}]
[null,"I",null,"UNSALTED BUTTER",100,{"$f":"IFERROR(VLOOKUP(D29,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D29,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":1.7066666666666667E-2},{"$f":"IFERROR(PRODUCT(G29,E29),0)","v":1.7066666666666668}]
[null,"I"]
[]
[null,null,null,"TOTAL COST",null,null,null,{"$f":"SUM(H26:H31)","v":2.8528666666666669}]
[]
[]
[null,null,"RECIPE NAME:","VANILA CAKE"]
[null,{"$f":"\"U-\" & D35","v":"U-VANILA CAKE"},"UNIT SIZE: ",1,"No"]
[null,null,"FINISHED QUANTITY: ",1,"No"]
[null,{"$f":"\"P-\" &D35","v":"P-VANILA CAKE"},"UNIT PRICE Rs:",{"$f":"IFERROR(ROUND(H46/D37*D36,2),0)","v":4.28},{"$f":"\"/\" & D36 & \" \" & E36","v":"/1 No"}]
[null,null,"PREPARATION","INGREDIENTS","RECIPE QUANTITY","RECIPE QTY UNIT","COSTING UNIT PRICE","RECIPE QTY COST"]
[null,"I",null,"BAKING POWDER ",100,{"$f":"IFERROR(VLOOKUP(D40,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D40,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":8.2400000000000008E-3},{"$f":"IFERROR(PRODUCT(G40,E40),0)","v":0.82400000000000007}]
[null,"I",null,"CASTER SUGAR",20,{"$f":"IFERROR(VLOOKUP(D41,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D41,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":2.1266666666666665E-3},{"$f":"IFERROR(PRODUCT(G41,E41),0)","v":4.2533333333333326E-2}]
[null,"I",null,"CHOC BROWNIE",50,{"$f":"IFERROR(VLOOKUP(D42,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D42,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":1.3317559153175592E-2},{"$f":"IFERROR(PRODUCT(G42,E42),0)","v":0.66587795765877955}]
[null,"I",null,"VANILLA",50,{"$f":"IFERROR(VLOOKUP(D43,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D43,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":5.5E-2},{"$f":"IFERROR(PRODUCT(G43,E43),0)","v":2.75}]
[null,"I"]
[]
[null,null,null,"TOTAL COST",null,null,null,{"$f":"SUM(H40:H45)","v":4.2824112909921128}]

{"sheet":"R-SANDWICH","index":7,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,1,7]]}
[]
[null,null,"RECIPES"]
[]
[]
[null,null,"RECIPE NAME:","Veg Sandwich"]
[null,{"$f":"\"U-\" & D5","v":"U-Veg Sandwich"},"UNIT SIZE: ",1,"No"]
[null,null,"FINISHED QUANTITY: ",1,"No"]
[null,{"$f":"\"P-\" &D5","v":"P-Veg Sandwich"},"UNIT PRICE Rs:",{"$f":"IFERROR(ROUND(H17/D7*D6,2),0)","v":2.6},{"$f":"\"/\" & D6 & \" \" & E6","v":"/1 No"}]
[null,null,"PREPARATION","INGREDIENTS","RECIPE QUANTITY","RECIPE QTY UNIT","COSTING UNIT PRICE","RECIPE QTY COST"]
[null,"I",null,"BREAD",2,{"$f":"IFERROR(VLOOKUP(D10,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"No"},{"$f":"IFERROR(VLOOKUP(D10,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":0.33333333333333331},{"$f":"IFERROR(PRODUCT(G10,E10),0)","v":0.66666666666666663}]
[null,"I",null,"EGG",1,{"$f":"IFERROR(VLOOKUP(D11,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D11,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":7.7777777777777776E-3},7.7777777777777776E-3]
[null,"I",null,"LETUCE",25,{"$f":"IFERROR(VLOOKUP(D12,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D12,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":5.0000000000000001E-3},0.125]
[null,"I",null,"MEAT",100,{"$f":"IFERROR(VLOOKUP(D13,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D13,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":7.0000000000000001E-3},0.70000000000000007]
[null,"I",null,"PEELED TOMATOES",50,{"$f":"IFERROR(VLOOKUP(D14,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D14,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":5.0000000000000001E-3},0.25]
[null,"I",null,"UNSALTED BUTTER",50,{"$f":"IFERROR(VLOOKUP(D15,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D15,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":1.7066666666666667E-2},0.85333333333333339]
[]
[null,null,null,"TOTAL COST",null,null,null,{"$f":"SUM(H10:H16)","v":2.6027777777777779}]

{"sheet":"R-DRINKS","index":8,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,2,1,7]]}
[]
[null,null,"RECIPES"]
[]
[]
[null,null,"RECIPE NAME:","BROWNIE SHAKE"]
[null,{"$f":"\"U-\" & D5","v":"U-BROWNIE SHAKE"},"UNIT SIZE: ",1,"No"]
[null,null,"FINISHED QUANTITY: ",1,"No"]
[null,{"$f":"\"P-\" &D5","v":"P-BROWNIE SHAKE"},"UNIT PRICE Rs:",{"$f":"IFERROR(ROUND(H16/D7*D6,2),0)","v":4.25},{"$f":"\"/\" & D6 & \" \" & E6","v":"/1 No"}]
[null,null,"PREPARATION","INGREDIENTS","RECIPE QUANTITY","RECIPE QTY UNIT","COSTING UNIT PRICE","RECIPE QTY COST"]
[null,"I",null,"BROWNIE",0.5,{"$f":"IFERROR(VLOOKUP(\"U-\"&D10,'R-CAKE'!B:G,4,FALSE),\"\")","v":"No"},{"$f":"IFERROR(VLOOKUP(\"P-\"&D10,'R-CAKE'!B:H,3,FALSE)/VLOOKUP(\"U-\"&D10,'R-CAKE'!B:H,3,FALSE),\"\")","v":1.06},{"$f":"IFERROR(PRODUCT(G10,E10),0)","v":0.53},null,"R-CAKE",{"$f":"MATCH(\"U-\" & D10,'R-CAKE'!B:B,FALSE)-1","v":5}]
[null,"I",null,"GROUND COFFEE",10,{"$f":"IFERROR(VLOOKUP(D11,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D11,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":3.2000000000000001E-2},{"$f":"IFERROR(PRODUCT(G11,E11),0)","v":0.32}]
[null,"I",null,"ICING SUGAR",100,{"$f":"IFERROR(VLOOKUP(D12,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D12,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":6.4999999999999997E-3},{"$f":"IFERROR(PRODUCT(G12,E12),0)","v":0.65}]
[null,"I",null,"VANILLA",50,{"$f":"IFERROR(VLOOKUP(D13,INGREDIENTS!$B:$G,5,FALSE),\"\")","v":"Grams"},{"$f":"IFERROR(VLOOKUP(D13,INGREDIENTS!$B:$G,6,FALSE),\"\")","v":5.5E-2},{"$f":"IFERROR(PRODUCT(G13,E13),0)","v":2.75}]
[null,"I"]
[]
[null,null,null,"TOTAL COST",null,null,null,{"$f":"SUM(H10:H15)","v":4.25}]

{"sheet":"R-Cat 4","index":9,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,2,1,7]]}
[]
[null,null,"RECIPES"]

{"sheet":"R-Cat 5","index":10,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,2,1,7]]}
[]
[null,null,"RECIPES"]